Tabela Evaluation

Definicja tabeli Evaluation

Name

Evaluation

Code

Evaluation

Comment

Tabela wspólna dla wyceny uslug i swiadczen


Lista kolumn tabeli Evaluation

Name

Code

EvaluationID

EvaluationID

ServID

ServID

EvaluationStatusID

EvaluationStatusID

Active

Active

InsertDT

InsertDT

LastModifiedDT

LastModifiedDT

StartDT

StartDT

StopDT

StopDT

InsertingPerson

InsertingPerson

LastModifiedPerson

LastModifiedPerson


Kolumna EvaluationID tabeli Evaluation

Definicja kolumny EvaluationID tabeli Evaluation

Name

EvaluationID

Code

EvaluationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli Evaluation

Definicja kolumny ServID tabeli Evaluation

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EvaluationStatusID tabeli Evaluation

Definicja kolumny EvaluationStatusID tabeli Evaluation

Name

EvaluationStatusID

Code

EvaluationStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli Evaluation

Definicja kolumny Active tabeli Evaluation

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Flaga aktywnosci w systemie


Kolumna InsertDT tabeli Evaluation

Definicja kolumny InsertDT tabeli Evaluation

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna LastModifiedDT tabeli Evaluation

Definicja kolumny LastModifiedDT tabeli Evaluation

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna StartDT tabeli Evaluation

Definicja kolumny StartDT tabeli Evaluation

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Evaluation

Definicja kolumny StopDT tabeli Evaluation

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna InsertingPerson tabeli Evaluation

Definicja kolumny InsertingPerson tabeli Evaluation

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedPerson tabeli Evaluation

Definicja kolumny LastModifiedPerson tabeli Evaluation

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli Evaluation

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Evaluation

Definicja klucza Identifier_1 tabeli Evaluation

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment